SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429628 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429628 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135858,606372,827275,673090,572728,1025019,869559,396916,450205,297283,163056,870426,237928,533142,333509,372993,190110,834371,706185,820255,135649,528312,24000,688557,872486,243877,791154,1031732,502375,538372,962436,458767,502872,745081,654242,543001,598075,1041520,822682,530039,259057,878872,357759,438055,625626,810767,524329,285994,706284,354073,23124,496781,989968,1000278,23858,764297,88246,546680,212674,25422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]