SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 613910 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 613910 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793992,472425,137797,454553,570267,512934,469668,285102,841384,568366,175354,111101,977788,217483,636647,122444,367027,35238,789718,776968,736536,529401,866917,733157,828462,626997,34926,254071,655795,227546,972232,819736,249050,781371,377593,72636,781982,421918,947851,437071,559282,1040612,587255,263202,668800,823274,657723,883031,936239,166115,559136,335580,777768,348112,476588,158366,1013235,613196,872586,282552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 613910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 613910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]