SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531405 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531405 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008608,64115,267583,155030,640498,853222,269090,750912,80943,18969,767686,870806,80794,481185,912791,476147,926834,433849,582338,933557,113025,701002,404543,902911,1031216,239478,924244,623063,105785,804578,392143,901111,435845,858911,890679,961925,638771,509461,37868,36848,169988,119516,185196,133816,454392,575551,357436,247163,924870,368989,916049,545328,34574,850858,645922,561475,730106,104833,600070,499396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]