SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591471 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591471 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004057,228205,1033308,158487,32153,1019098,237298,421912,940860,61552,215261,629842,958853,860569,428250,40585,278515,999072,186745,480006,76825,721648,614811,788957,516262,86946,337660,364802,1006944,187312,53605,596348,588367,63434,905930,553536,272335,596380,662863,390679,421636,18484,454597,185122,286327,733066,1047403,398446,897402,312132,104126,184858,523385,62820,7780,426971,914577,785446,175522,320469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]