SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150841 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150841 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311206,420221,893542,179017,591543,654696,64505,51065,337401,100948,1043471,485471,749628,944692,206398,942625,48116,764524,904756,989825,812056,607176,451074,445911,171687,986686,679585,501523,684089,1019292,156903,533636,975324,250240,370485,595577,235072,339986,201019,336418,593660,792921,864786,1032916,982817,490997,191139,523785,913800,1037302,836212,967997,1044582,575033,820940,423838,408888,327903,813466,684361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]