SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394510 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394510 [ RunTime:0.002389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774518,404094,1040292,345778,915269,25733,907756,884793,1023333,423699,609647,706204,82509,61874,1016392,789514,322472,95519,760614,1006750,310336,106090,611174,247726,907317,851576,503714,197750,974133,23457,992644,123054,962985,994880,388666,7913,941056,657807,843033,532269,489478,73063,970208,506534,711782,376001,566782,983394,346345,476160,494834,280846,75901,819077,689122,753420,721856,184773,610918,356447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000920s ]