SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300018 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300018 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161696,130094,1014120,839207,870706,57435,213077,995756,916922,90344,749355,783779,670836,1000720,1013026,740267,42642,752164,587975,545755,865565,580324,952152,309755,88826,406759,8640,568993,179706,777092,326107,1024741,229538,164784,984819,175552,846381,138320,539308,632796,1031130,342303,121361,627434,414617,962647,250583,630184,726877,600355,916974,794433,648180,213730,436874,563511,876081,516058,474531,925910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001149s ]