SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991810 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991810 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557846,409382,877238,920544,682377,823558,670643,222766,908546,33560,563517,737390,90706,1011844,198567,550351,917195,804162,25204,191686,255633,554024,700023,1000269,452745,620162,1012094,289276,55118,119121,703756,314928,775899,635341,510028,777890,817000,756144,1016655,1031009,10550,709844,167998,558507,253037,92075,220847,848956,119633,900962,825096,368323,798285,688984,523132,170103,496722,190064,437951,323559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001974s ]