SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040611 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040611 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239372,504901,725482,966503,614059,585054,612237,630235,198186,599864,223376,935593,531503,237958,59474,140292,986737,204607,1005795,510506,626958,278914,526769,636363,570521,948631,48337,299776,821654,889144,179314,752177,843888,896040,319729,274840,295593,416688,372009,1030938,336585,123600,615631,2036,43489,625909,902374,340813,248053,831860,942652,523522,422871,872251,195730,333614,283722,459539,210977,399550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001969s ]