SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534318 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534318 [ RunTime:0.004593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453314,835915,145824,603124,583176,634457,269379,353950,990499,899896,11972,943236,514003,26365,923632,1016587,882489,938595,475076,373104,447338,233298,713404,620396,147655,899114,540354,854671,187526,524829,746513,441954,245150,292602,1616,50464,770081,208137,213282,2157,294405,906215,888647,294562,876396,946874,954335,351797,683339,137956,419244,102252,490729,868236,641950,793082,751599,721690,391072,894731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000690s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]