SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314215 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314215 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444880,697993,361843,130844,158285,410513,920000,130212,401521,310612,645696,257821,998250,155000,142910,699379,29940,173528,274333,477281,829411,102400,893807,221250,414439,278668,784403,536865,886792,644190,358531,738664,13121,989154,485386,69434,880011,569041,517518,681351,836012,699620,609115,449739,342339,59772,144877,567726,878971,729440,612592,110092,3501,916733,519945,695082,221549,142033,629002,704515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]