SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573415 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573415 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839241,590815,646973,540256,717386,737540,134625,311942,770852,772398,642810,514825,785236,786591,94116,898863,512571,605290,912500,692022,813058,715908,178980,126224,907493,397100,785605,711824,931675,528161,385998,762902,877571,378341,572632,659682,198554,1029055,780458,775889,28342,1040197,413216,779928,709735,652240,903065,372006,436265,779909,6921,23980,1011191,667040,719945,53443,689618,809916,937605,77472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]