SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506543 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506543 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858576,337437,83521,640788,969855,605967,642160,536209,1025479,530244,1017293,239910,709855,588489,635437,948943,597286,337019,67359,992855,757484,550122,7626,742523,147160,159393,992320,123303,58533,253036,964167,208758,621743,137311,260452,580586,711248,83104,701654,875431,560664,765738,198303,1046349,802710,896842,1036219,1019215,22360,886443,842815,897831,339977,665962,981996,772189,445801,768738,659403,509641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]