SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537923 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537923 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74338,357021,793113,969382,560542,511480,505593,737834,214685,346995,567788,570952,795459,1006705,194471,219547,770267,102806,683507,894972,150907,296560,577151,370038,1017751,315642,308328,278548,230023,860046,508655,1045593,52527,10340,64918,113230,642380,543885,672481,690462,797412,463858,713455,357517,346535,770564,146550,968134,644489,431533,547433,16009,1011216,819826,793788,387305,1008087,940690,154945,515428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]