SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017286 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017286 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391491,294177,516056,735068,73933,429136,331160,501912,609687,76994,808548,406320,522125,792648,454816,201039,481395,976313,740214,366847,900323,584592,692817,333933,883235,49812,94825,998708,500350,740057,325146,728963,818032,1028128,289185,199162,823374,588477,827866,655692,654635,547835,690715,1018325,823382,26904,309336,661641,428483,967,173709,183247,882491,219038,952133,1013113,861631,297852,882310,976803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]