SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205080 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205080 [ RunTime:0.002793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011370,353320,62091,105642,700577,18490,1000447,22336,678198,314470,718136,354778,914483,890303,475857,368286,282011,488538,635846,232461,1043812,375960,331936,674141,325735,13239,975347,974004,492669,734809,840156,965844,851861,904855,656747,1028317,960192,182130,713951,206263,173241,732335,1038605,655328,913105,515903,723073,321889,14827,1009377,331804,171036,467017,816456,278822,932273,313344,974099,79549,201702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]