SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502540 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502540 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745670,151001,424182,788263,927015,693842,935787,212888,48982,658778,1042685,123475,478654,846544,596103,822242,406856,26821,77577,213180,445713,369867,616087,838199,426416,156764,119168,706775,492224,902049,398126,74304,137429,1022186,589033,548725,755270,819165,1002386,365179,572144,1036858,370217,458089,404162,94078,618460,166008,135229,285967,1013250,632422,513680,224292,726852,803739,320679,988526,786196,699148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]