SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593498 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593498 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407862,287272,763738,129833,488504,43316,1042580,843621,709398,503330,533718,440402,1000228,556137,664422,211413,486228,835753,417288,198275,320423,43367,48812,921240,391114,891909,613220,887382,202144,114436,1001093,896567,947295,54500,90158,231046,282852,998072,757707,532018,119002,672470,728735,941666,387369,58656,424772,761817,851845,707078,624097,873646,53495,728107,399005,546089,760317,325867,115665,871264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]