SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416015 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416015 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394711,452949,501005,220662,121932,738755,263170,262463,316887,830627,474534,383819,882525,435258,390405,348914,761488,391543,822573,158560,954244,175157,208972,358462,912837,299321,564934,429137,564247,626891,386280,1042730,435746,625538,313081,740111,35831,834537,626956,182453,758855,709852,447391,774707,1014166,761313,269812,542103,823165,788013,937197,336974,277808,479361,569135,470338,985005,443207,441540,1744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]