SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498884 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498884 [ RunTime:0.007247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275558,427419,203916,989253,778863,303131,545575,219903,173903,805943,892327,331684,466353,433026,198527,891506,6177,924823,10719,688711,876210,1046114,1045391,316582,926578,373225,1043278,983374,121311,490357,752675,790204,425144,167974,841069,314958,575522,224396,285871,34361,304309,234413,112196,510983,794028,361543,363805,462125,948584,843244,308893,293895,816968,875415,600164,969390,535773,274734,218913,358018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]