SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529483 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529483 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312305,136959,692553,300327,18245,169965,945816,677823,75412,605393,78418,1005942,76981,617273,203711,837043,497688,806507,959186,125986,733098,926426,813977,968590,963788,22248,270309,979640,953923,781859,215461,893388,210138,636722,641826,257680,785925,227175,868830,711044,305900,1030295,76267,676922,889048,768885,135778,26636,263577,334001,787377,743934,385256,1012627,515708,105302,964420,839160,348326,404227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]