SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559417 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559417 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44305,325643,476561,91797,359700,970406,868391,524809,703068,355436,1023244,523636,176386,990548,814978,923916,723528,482657,878129,228404,512507,1833,713770,831256,306895,963582,307054,930218,759215,846092,668820,669035,840912,804446,89595,943517,776129,92451,216521,75244,99564,989589,226612,991220,369520,1045987,1047342,331207,79355,115621,431058,685986,522776,955323,143777,434168,576974,270827,422784,734673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001606s ]