SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408104 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408104 [ RunTime:0.003384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779113,76868,125897,598905,364838,724161,726594,210515,850437,874542,599354,195730,874956,827348,257432,26992,883939,129093,404877,471057,282386,60888,418522,1034766,283224,287059,264630,578783,115263,871905,851559,243360,938194,656867,520368,533112,681434,534384,15477,674084,866740,768815,55327,778682,632002,888847,669404,995116,236576,77692,77205,708454,378146,811182,217961,1017027,947114,647982,152194,331771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001285s ]