SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336180 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336180 [ RunTime:0.004177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87810,976539,773435,556142,931624,834718,1037786,58844,786588,94507,560525,783234,505541,879219,903639,435304,220186,250619,392890,565444,385403,763598,492689,1019496,625928,470993,466872,44551,263198,852255,458163,503592,707724,836544,50580,954569,919906,930637,531129,214173,373794,1044129,83253,298155,307820,692379,730388,917984,824454,741238,521452,796755,1046630,69006,699378,739980,660070,386983,619086,52299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]