SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438716 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438716 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380112,196003,300170,919874,947222,295047,633360,743550,753473,285209,269274,506789,745192,727671,792906,758482,147601,710725,43793,842702,552850,732052,411560,557100,581931,844073,834187,564805,1011490,286389,172718,380119,331885,881274,25602,794422,184488,518639,647608,609247,22210,534269,897972,625475,775213,385992,58442,998641,211907,1000870,344860,667371,415687,964886,929211,536431,835043,560529,878822,543106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]