SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558971 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558971 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655946,1042261,359572,569457,435729,182495,125366,709455,565818,696428,593259,1004536,42791,647130,964924,983618,335977,267697,691629,687078,114163,7814,35868,681092,206785,185541,344794,507666,1606,77385,631232,93425,835203,16584,873116,125875,40087,615008,760960,1000618,151967,504862,306855,689016,132355,734491,320162,424094,159080,558836,1015470,458753,992000,815274,927775,102451,131698,609325,169355,139225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]