SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330089 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330089 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120539,182133,233471,72209,957348,118917,444867,364981,280661,182682,39140,866719,602692,629724,166094,680032,491470,407428,39504,580270,1019089,658138,515348,402260,93481,89353,121753,486069,23794,862683,933650,897910,941018,752993,800302,890739,745005,939346,615885,793634,799911,615111,131092,803617,878691,762010,178500,161529,76189,302080,115467,850128,448676,669951,126714,683080,56666,228495,503578,335656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]