SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525658 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525658 [ RunTime:0.003671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627112,198241,1019981,734850,9651,455184,583425,139263,590973,384936,286545,854530,763299,516124,351476,849253,21840,535060,933,53711,443101,824932,772878,459634,810476,459206,101148,694634,671885,900407,269947,643183,965222,468862,796917,250815,734414,846180,383547,62219,577918,3259,355813,176408,966624,505139,231390,550309,773960,1046840,1001255,847593,653706,922241,912217,937712,337605,879785,316339,593422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]