SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038722 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038722 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648263,437452,1043399,277991,260976,340380,418010,562880,321072,2559,826180,131491,327592,297572,566775,667579,298868,59511,42268,739594,771121,981407,493323,1030826,426376,31382,796175,946337,291106,360976,427330,956011,168077,774199,713379,664258,7374,919451,832019,543324,755165,123113,854842,273756,79507,46573,154216,1029976,385642,283666,466875,251067,498723,524715,603327,250812,374707,897242,7908,588991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]