SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414710 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414710 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754566,666328,269480,356502,599709,535959,232819,483755,961996,389870,387450,523593,551331,207447,667171,542436,967375,906747,843697,746107,995114,678169,67261,354449,242627,835416,1008064,766280,392685,546800,958294,59627,423015,214070,798197,682293,512168,66130,529800,498070,182814,14128,429788,179559,1031145,786109,634433,281031,937506,888090,199162,272277,480920,309289,516858,961205,876692,124656,853762,205829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]