SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801870 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801870 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470844,407900,856613,876653,174487,79071,282008,534479,457812,965127,13348,518301,572679,201951,819682,204027,358076,226323,585084,266183,224676,1040948,410482,978202,406215,88037,988969,765200,328374,805816,168769,831061,240153,959133,189527,249623,884590,194575,678404,370882,126057,325626,292256,463701,787386,793437,892763,840640,1029934,846694,555698,562121,648274,608107,724970,814913,124265,502231,920178,617436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]