SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549258 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549258 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878348,522544,1029117,25579,640289,778742,6201,108950,724389,676425,238165,642606,945633,349208,677786,6164,544309,789122,425050,353283,464639,80490,539749,939608,531154,607571,556658,1021085,801088,236562,266550,30679,985507,320488,25032,837855,494666,232032,393201,193160,526191,732858,349650,914365,954228,804201,23646,626240,817625,342166,111356,467255,1881,1002313,105904,435484,763140,875846,743185,387022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]