SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484306 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484306 [ RunTime:0.002306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554117,200085,571397,196445,179983,485850,768962,754289,958551,1018712,805867,600065,717337,900371,831419,517331,2696,769317,320477,410467,643515,478953,344901,51141,300895,367246,1032592,1042979,919870,716003,43769,792103,896498,786468,361050,476516,990584,731721,83573,497326,70008,138818,948979,222942,716555,573220,440910,238438,877133,830617,693658,619638,241619,680459,744598,336404,531469,347688,125087,756419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]