SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038491 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038491 [ RunTime:0.006995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930902,1026575,116157,869129,1024089,297930,102375,625972,926955,187194,13656,540926,368086,63291,789000,48795,596440,936026,83129,299500,815748,830656,1034087,696739,909166,194624,265728,773155,986247,144485,456434,879434,887663,835501,517560,606681,112417,23389,133212,929756,664601,767601,316381,388909,810386,601319,216258,123029,209778,84124,859232,640867,947523,620915,447332,660356,945774,440465,610692,200466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]