SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197835 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197835 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902274,411682,357485,35884,804606,759673,162244,13145,1013729,704579,506633,611010,1047473,375295,580706,307312,402118,1012008,195804,16764,267487,368520,484551,1025350,100218,883476,913815,315595,311076,970497,562495,773566,569148,530486,123024,578750,749756,765248,182922,733973,999188,659284,255293,869789,828507,26194,157709,552103,966918,405524,508989,191914,27589,185352,907193,1019063,948274,420851,189505,196454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]