SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575445 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575445 [ RunTime:0.004118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749024,1006095,718945,421827,10337,46670,303236,117946,629543,746605,253041,28735,97953,1041751,896486,132861,839716,362757,198848,608683,393920,261286,219609,890799,72517,363496,811975,512961,474020,507895,119386,881086,58268,108502,534724,689797,110698,644753,547748,511924,249872,694153,249431,860087,717193,138714,100197,295138,107672,142489,207228,831027,511452,60760,560383,148104,426793,422524,303479,294502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]