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` = 511095 LIMIT 1 [ RunTime:0.001258s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511095 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63861,607934,89143,487903,551103,568108,732730,533607,765461,864022,1035560,540106,69070,118339,371911,11047,650503,382441,684405,642237,384911,513089,929047,966333,876714,818178,364508,139080,543779,998082,227484,534055,630011,292964,86644,399722,341444,308684,1034670,140111,737966,650120,913712,920498,161078,98626,119620,530049,174635,645919,108957,851318,131682,559976,275255,905844,1029344,1007539,640180,106471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]