SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413126 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413126 [ RunTime:0.005853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026775,431442,678527,221443,288164,507053,957179,134393,61432,887068,706025,457597,890976,571779,46559,115300,419901,371707,26582,776641,1024807,748409,93665,638823,737192,329323,456013,73227,712014,581607,277584,1040965,452703,233659,620382,684235,219075,748617,836493,623342,940943,810674,894086,181689,160354,169456,222024,108377,180629,40614,541086,375606,862744,188583,358940,272387,618553,674501,1042044,583758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002607s ]