SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549412 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549412 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641504,256441,791877,688690,124065,405572,576633,122710,1018883,14247,197873,424908,447877,214255,311885,751264,270507,1042063,925221,264101,998258,107594,994195,31756,1015169,955198,117058,19193,971615,434441,948870,821108,308021,418638,135116,599777,309744,656574,7307,1032691,27570,33500,987397,280109,1037482,515161,800805,939128,643860,897626,682158,716348,623691,182704,709837,744208,370352,290749,644112,893523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]