SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668412 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668412 [ RunTime:0.003882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710156,524431,761529,699950,881137,866499,996421,122261,1034872,392608,916981,342304,166309,122603,85514,194951,493082,627160,488432,278660,609327,1031446,906196,349147,792866,821912,715579,221386,410452,143686,1044230,432326,92255,943869,28158,771935,606906,413881,681055,641996,217097,105832,379992,149260,360170,468799,656280,108272,439347,388900,529070,514513,477711,555215,754879,770169,122354,754529,607804,953196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]