SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620593 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620593 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104995,40527,45894,366338,850900,195537,714897,65385,721282,499703,634483,910694,509866,599482,884027,820251,1003171,900176,731741,878804,113583,656764,642028,171643,151545,243004,781149,807847,420180,657050,239598,306185,350249,976415,607225,899698,107575,786856,934205,284989,59147,132547,49249,832582,143506,36764,980572,632073,2859,829912,462834,319222,899289,375865,369875,680091,579039,474395,77744,667746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]