SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104063 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104063 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273701,423560,1036226,852170,687466,220521,377819,440695,46622,316570,931689,819944,313429,578957,599141,361077,462073,7603,981906,887107,951637,522249,991950,761780,997565,167284,275138,354699,643478,120071,856458,216347,60767,511911,694857,812610,861887,364764,763835,990099,175246,545074,340691,202344,245837,419103,837688,546698,806910,304401,310422,214259,122297,400735,850476,532230,678288,178916,287511,770163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]