SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030513 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030513 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486351,454013,140619,380837,249777,881272,735503,68677,700713,45944,53591,789175,455837,534152,900293,786249,543476,74542,477548,15194,74517,389876,442334,282544,784150,608859,421806,654555,681669,738638,456542,627767,641076,300934,298455,837797,284644,505874,140595,50274,896505,460129,280201,549025,536944,54592,440028,200515,325752,532221,395229,674567,153911,281256,379060,454321,380467,596338,219532,506473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]