SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405044 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405044 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233530,783038,436639,908223,107289,975186,63310,197558,64008,704293,624975,622074,352412,559560,1013649,580519,494893,598483,529221,440217,319927,2027,945277,943526,535702,217121,420189,525378,257614,983572,71644,154003,446466,495486,876054,1010133,520612,471334,513937,241177,764412,252235,874372,790549,391435,483870,702823,725596,634837,974684,674697,957940,781100,160654,329481,910753,907681,434897,569464,13461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]