SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022106 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022106 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498776,208165,701912,40322,392665,291850,462049,269982,880178,370616,276524,195376,66286,1016565,8722,743739,696713,98118,228970,267983,652724,194068,223548,651854,499652,73755,19644,688483,37462,588088,677693,129941,381909,629477,72288,358081,417964,220418,249307,1001660,581947,722389,88951,284019,423672,675162,472493,591451,232819,986598,940807,139154,12057,240577,604571,271822,829392,184644,836060,51115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]