SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312831 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312831 [ RunTime:0.003033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533427,371348,984973,523339,89132,262913,183527,1031635,953608,981468,376995,327759,62698,553513,691550,298961,174299,475780,829677,606887,829192,312042,103496,219566,316627,5672,188347,963971,831549,1038807,496100,34380,315728,301607,984950,421739,30655,335144,958423,1048202,235289,379404,277995,109544,434239,692711,911750,155041,860683,804049,621884,314235,850154,621934,720166,124142,1032469,1039338,693947,428924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]