SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381001 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381001 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84201,296511,780773,714143,116420,969099,356560,447665,1028186,137070,956573,888369,843510,542774,544331,704495,798789,822137,95637,257844,241564,878230,224541,430467,829842,380379,799960,306287,688335,865151,588366,569,890702,810099,774821,285651,894385,971827,247975,149033,768739,1286,960167,75663,231075,998670,954468,989829,428132,434130,406160,906336,282948,859398,540571,305554,890428,1044508,370968,470755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]