SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482682 LIMIT 1 [ RunTime:0.003647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482682 [ RunTime:0.006233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662570,552642,354666,273893,362104,221809,849781,1042421,782997,1025988,771287,168682,382850,736212,1043743,225206,885261,563213,709286,813728,674373,945154,935426,607306,439882,598273,240404,526963,551074,480000,334139,1031800,145761,704957,278869,741926,372673,814663,460942,868299,93190,10611,396307,807997,360103,799165,301453,638557,480123,976334,713495,831497,514363,750539,1034849,320408,760286,635679,824938,317329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]