SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475016 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475016 [ RunTime:0.003914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314830,717499,147327,369977,619124,938532,875114,860427,644923,24071,674396,581898,569412,920410,812332,93517,782713,850467,563302,274206,512572,740686,135446,651415,177236,475306,611019,275141,801209,836758,197003,908037,813270,825375,316767,104447,461666,86069,729591,434342,401988,674168,912631,440618,331213,152796,757738,412354,1018749,353689,248405,842050,210274,381048,194948,803,10466,176183,305688,788418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]