SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397213 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397213 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928506,621617,14762,239173,580300,21524,386673,540096,698963,458313,383395,211004,42018,419488,168062,64602,697339,759208,559380,355329,539836,292256,60968,341601,502358,206554,142810,765710,971946,883496,464201,944735,913388,426004,290115,910190,883280,494633,423303,739716,253561,636503,740602,605488,870213,120319,734837,978358,132315,434547,402905,884923,383422,802087,73116,211132,738229,519306,319396,967440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000998s ]