SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006935s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587928 LIMIT 1 [ RunTime:0.001058s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587928 [ RunTime:0.011934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492541,358395,798634,1015295,784412,592400,591000,673635,501391,1021131,714912,173540,185546,639339,59654,562796,741873,1030574,835921,427093,656384,918582,355936,138528,619828,408723,303350,38583,728405,177715,4146,665331,507020,13115,1044209,153482,881548,202203,880401,16134,623195,1037125,975689,319970,97902,57218,790348,105707,110782,974604,832335,986895,894692,235748,349932,456067,1034833,95811,394580,968677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]