SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333306 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333306 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004192,644135,625089,67632,244575,956729,561893,717051,989030,971971,200081,811671,1004138,116014,750627,117261,516989,609107,703503,339434,59247,575737,451604,46572,588753,472354,958056,813678,453120,652460,153390,506992,510281,896397,910128,816010,332773,473850,113146,883857,632296,926431,472121,138146,284173,547423,863261,134196,933031,500358,707698,223145,810679,71347,754868,501241,505874,836443,19652,499632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]