SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978008 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978008 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327228,710411,718476,898879,943803,843591,811762,928611,110744,751364,323396,849958,82057,964277,221868,629636,717009,630494,489104,383541,736544,492877,977592,701140,595198,200430,453587,254728,623445,476379,364699,535434,469002,774355,296888,121762,662082,896555,237995,256074,603,1004100,798358,339101,1008709,853070,463061,142992,929087,47706,725755,815628,431403,794581,1002637,986364,720521,760286,401644,258514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003294s ]