SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491283 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491283 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305540,788764,75370,675839,869266,652651,922472,39903,120766,944602,537439,556925,880672,312768,703138,52982,999359,642028,768233,529492,538132,892427,804368,1042951,266715,183799,198984,895939,395749,376569,156823,675638,220345,854594,795471,9430,363368,1007449,193410,455108,194635,355153,569322,433035,457598,604399,628021,625479,526099,313796,956676,707122,307678,45489,40809,126436,699219,383326,399395,288399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]