SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021201 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021201 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26992,268568,807424,998364,993889,471311,313000,950162,960260,912163,267229,418140,191672,343007,153792,366789,147062,739339,975472,395573,566911,997748,809444,1002634,103596,239668,182377,397600,60391,764076,26647,170568,305455,271602,726995,720981,394472,1023591,59218,740768,786954,59447,642596,915736,630241,563164,357385,656729,710820,849716,1003613,418137,551293,777448,873324,290045,552621,873715,685393,345818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]