SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015254 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015254 [ RunTime:0.004577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674947,526582,769295,401488,684053,697756,360096,579775,246191,33504,901966,486181,122481,996738,506021,401042,528617,865309,200019,271152,307331,4964,803646,130049,42959,882262,24081,795879,536209,24299,959851,731549,63896,830227,663914,681149,308239,886295,919650,23965,737206,269731,999787,952004,108410,409370,70186,140726,71769,135908,359497,716330,595964,1036020,968209,112893,918386,272417,464971,589115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]