SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154102 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154102 [ RunTime:0.003747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284295,979896,385619,1043963,428971,168118,818731,503696,748365,334769,20685,896438,620926,812867,487235,454998,414255,911693,468130,1017704,972660,1007196,503482,249460,127528,306352,209130,741949,646888,949544,384185,770795,444252,511954,268778,48808,1014007,300846,150674,662751,938802,992642,26910,266411,726805,770484,146839,583479,196082,426521,928204,1024154,767257,798834,429215,555989,635250,427868,1009413,196734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]