SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483643 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483643 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018898,714787,930704,755887,671378,941982,61748,392330,757788,839446,283638,608306,909716,829007,688987,500494,744925,279917,790082,1028003,483145,715933,113568,241365,1023599,38237,68905,426531,142545,788153,205600,950374,951618,1020845,266141,504162,261270,272940,886367,495050,673273,598663,440638,838675,1011331,459085,522930,619405,527177,849129,77600,848483,1008947,888270,626835,922681,577674,338630,254876,974204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]