SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442053 LIMIT 1 [ RunTime:0.002171s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442053 [ RunTime:0.003328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803378,407694,122480,696045,1043715,548709,903873,842622,360571,6250,748451,932377,579645,40044,832087,367871,847347,739408,767887,546680,204116,987275,161631,390178,510076,507148,153524,674783,623398,1013608,825639,7164,137314,846101,79995,932266,263344,998875,645969,656436,781133,1024397,389427,624868,513448,22289,774276,867210,383237,968114,93275,950427,894362,759881,733395,590877,612100,305250,352572,605571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003033s ]