SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036694 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036694 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407443,369487,626776,780755,374502,551020,499500,956721,575689,847000,1005373,919913,526805,713543,424919,428919,1036954,162784,546484,631579,520844,752466,52708,712067,1010177,625856,860861,899699,64687,185292,139529,472524,133776,996351,684631,246979,641292,442188,551115,899836,98324,764061,521457,424955,1040445,667328,951389,521496,203719,561777,389001,597523,373510,1045419,891307,47762,1028349,227592,575826,912883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]