SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28275 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28275 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284215,20281,278683,570596,1019753,427749,429188,512261,368641,94960,988835,392457,641200,845788,854924,876492,87518,400936,689206,15116,18031,1004408,141747,1021770,648328,968644,165565,689947,730740,43769,167095,309468,587064,1005340,469738,24779,531433,546180,935271,569955,596376,330867,555329,1001386,403907,480429,333002,536532,1020885,77215,1000477,347689,113856,397695,734469,489666,1016295,85795,778607,10279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]