SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012028 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012028 [ RunTime:0.002783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904667,104977,1046223,676131,318062,351580,198371,492915,352495,46591,2378,610249,905548,536303,480314,194279,228709,798136,138652,785728,1014354,644462,240769,16244,789539,171301,937410,715899,598624,57870,403717,344707,912628,608496,367923,726893,293391,319869,892988,122329,869662,828551,159193,727819,222251,447624,960211,252899,578771,993975,637700,1041094,629473,178218,621212,1039954,922537,209036,200176,161316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]