SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380931 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380931 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040164,47269,264876,90194,152672,159915,152304,277125,556220,631004,541983,593293,520284,410786,921429,121768,804400,342538,664203,299709,328191,441249,690340,313300,607104,907345,811404,18418,589210,677730,63246,611647,875213,717119,851087,62895,334419,1018670,406338,254531,15651,934960,719606,531430,995795,171857,846979,312158,856621,788220,435818,398667,303357,720416,784841,887469,269344,189383,94974,5592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]